Data
basic EDA
## LOCAL_DATE x y TOTAL_PRECIPITATION
## Min. :1940-04-19 Min. :-122.8 Min. :53.83 Min. : 0.000
## 1st Qu.:1959-01-28 1st Qu.:-122.7 1st Qu.:53.89 1st Qu.: 0.000
## Median :1980-11-07 Median :-122.7 Median :53.89 Median : 0.000
## Mean :1981-01-11 Mean :-122.7 Mean :53.89 Mean : 1.611
## 3rd Qu.:2002-08-18 3rd Qu.:-122.7 3rd Qu.:53.89 3rd Qu.: 1.600
## Max. :2024-05-28 Max. :-122.7 Max. :53.89 Max. :50.000
## NA's :347 NA's :347 NA's :570
## STATION_NAME MAX_TEMPERATURE MIN_TEMPERATURE TOTAL_RAIN
## Length:31817 Min. :-36.900 Min. :-50.000 Min. : 0.000
## Class :character 1st Qu.: 2.200 1st Qu.: -6.100 1st Qu.: 0.000
## Mode :character Median : 10.200 Median : -0.300 Median : 0.000
## Mean : 9.574 Mean : -1.742 Mean : 1.152
## 3rd Qu.: 18.300 3rd Qu.: 5.400 3rd Qu.: 0.500
## Max. : 38.900 Max. : 20.700 Max. :50.000
## NA's :267 NA's :246 NA's :5336
## MIN_REL_HUMIDITY LOCAL_YEAR LOCAL_MONTH MEAN_TEMPERATURE
## Min. : 11.00 Min. :1940 Min. : 1.00 Min. :-41.500
## 1st Qu.: 37.00 1st Qu.:1958 1st Qu.: 4.00 1st Qu.: -1.800
## Median : 51.50 Median :1980 Median : 7.00 Median : 5.000
## Mean : 53.09 Mean :1980 Mean : 6.52 Mean : 3.924
## 3rd Qu.: 69.00 3rd Qu.:2001 3rd Qu.:10.00 3rd Qu.: 12.000
## Max. :100.00 Max. :2024 Max. :12.00 Max. : 26.900
## NA's :23413 NA's :347 NA's :347 NA's :434
## LOCAL_DATE x y TOTAL_PRECIPITATION
## Min. :1992-12-04 Min. : NA Min. : NA Min. : NA
## 1st Qu.:2015-12-14 1st Qu.: NA 1st Qu.: NA 1st Qu.: NA
## Median :2017-03-07 Median : NA Median : NA Median : NA
## Mean :2015-10-24 Mean :NaN Mean :NaN Mean :NaN
## 3rd Qu.:2017-11-16 3rd Qu.: NA 3rd Qu.: NA 3rd Qu.: NA
## Max. :2018-10-28 Max. : NA Max. : NA Max. : NA
## NA's :347 NA's :347 NA's :347
## STATION_NAME MAX_TEMPERATURE MIN_TEMPERATURE TOTAL_RAIN
## Length:347 Min. :-19.100 Min. :-29.050 Min. : NA
## Class :character 1st Qu.: 3.175 1st Qu.: -3.850 1st Qu.: NA
## Mode :character Median : 8.600 Median : -0.400 Median : NA
## Mean : 9.019 Mean : -1.853 Mean :NaN
## 3rd Qu.: 18.400 3rd Qu.: 5.150 3rd Qu.: NA
## Max. : 28.700 Max. : 12.300 Max. : NA
## NA's :228 NA's :222 NA's :347
## MIN_REL_HUMIDITY LOCAL_YEAR LOCAL_MONTH MEAN_TEMPERATURE
## Min. : NA Min. : NA Min. : NA Min. : NA
## 1st Qu.: NA 1st Qu.: NA 1st Qu.: NA 1st Qu.: NA
## Median : NA Median : NA Median : NA Median : NA
## Mean :NaN Mean :NaN Mean :NaN Mean :NaN
## 3rd Qu.: NA 3rd Qu.: NA 3rd Qu.: NA 3rd Qu.: NA
## Max. : NA Max. : NA Max. : NA Max. : NA
## NA's :347 NA's :347 NA's :347 NA's :347
## count_missing first_missing_date last_missing_date
## 1 347 1992-12-04 2018-10-28
## x y LOCAL_DATE TOTAL_PRECIPITATION
## Min. :-122.8 Min. :53.83 Length:31470 Min. : 0.000
## 1st Qu.:-122.7 1st Qu.:53.89 Class :character 1st Qu.: 0.000
## Median :-122.7 Median :53.89 Mode :character Median : 0.000
## Mean :-122.7 Mean :53.89 Mean : 1.611
## 3rd Qu.:-122.7 3rd Qu.:53.89 3rd Qu.: 1.600
## Max. :-122.7 Max. :53.89 Max. :50.000
## NA's :223
## STATION_NAME MAX_TEMPERATURE MIN_TEMPERATURE TOTAL_RAIN
## Length:31470 Min. :-36.900 Min. :-50.000 Min. : 0.000
## Class :character 1st Qu.: 2.200 1st Qu.: -6.100 1st Qu.: 0.000
## Mode :character Median : 10.200 Median : -0.300 Median : 0.000
## Mean : 9.575 Mean : -1.742 Mean : 1.152
## 3rd Qu.: 18.300 3rd Qu.: 5.400 3rd Qu.: 0.500
## Max. : 38.900 Max. : 20.700 Max. :50.000
## NA's :78 NA's :62 NA's :4989
## MIN_REL_HUMIDITY LOCAL_YEAR LOCAL_MONTH MEAN_TEMPERATURE
## Min. : 11.00 Min. :1940 Min. : 1.00 Min. :-41.500
## 1st Qu.: 37.00 1st Qu.:1958 1st Qu.: 4.00 1st Qu.: -1.800
## Median : 51.50 Median :1980 Median : 7.00 Median : 5.000
## Mean : 53.09 Mean :1980 Mean : 6.52 Mean : 3.924
## 3rd Qu.: 69.00 3rd Qu.:2001 3rd Qu.:10.00 3rd Qu.: 12.000
## Max. :100.00 Max. :2024 Max. :12.00 Max. : 26.900
## NA's :23066 NA's :87
check temp dist for in a random day from all year value
## STATION_NAME
## 1 Prince_George
get 90th from the all year for all day value
Plot
plot given year temp dist vs baseline 90th


EHF plot

plot all year temp in grey vs baseline
## Warning: Removed 396 rows containing missing values or values outside the scale range
## (`geom_line()`).
## Warning: Removed 1 row containing missing values or values outside the scale range
## (`geom_line()`).
## Removed 1 row containing missing values or values outside the scale range
## (`geom_line()`).

## Warning: Removed 395 rows containing missing values or values outside the scale range
## (`geom_line()`).
## Warning: Removed 2 rows containing missing values or values outside the scale range
## (`geom_line()`).
## Warning: Removed 1 row containing missing values or values outside the scale range
## (`geom_line()`).

Analyze the hw
hw dist for certain 1 year
prepare for the data
## # A tibble: 24 × 7
## Month Day Percentile_90 MAX_TEMP_YEAR DayOfYear Condition Cumulative_Count
## <int> <int> <dbl> <dbl> <dbl> <lgl> <dbl>
## 1 1 11 4.31 5.5 11 TRUE 1
## 2 1 12 4.52 5.5 12 TRUE 2
## 3 1 27 4.4 5 27 TRUE 1
## 4 3 17 10 11.2 76 TRUE 1
## 5 3 18 10 12.1 77 TRUE 2
## 6 3 19 10 14 78 TRUE 3
## 7 3 20 10.0 15.7 79 TRUE 4
## 8 3 21 10.0 15.7 80 TRUE 5
## 9 3 22 10.4 14.5 81 TRUE 6
## 10 5 9 21.1 25 129 TRUE 1
## # ℹ 14 more rows
plot hw analysis for all year
plot overall count of hw through years


seperate view of the heatmap
examine specific year